<%@page import="java.sql.DriverManager"%>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1"%>

<%@ page import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Add New User</title>
</head>
<body>

		<form id="add_user_form" action="add_user" method="post">
			<br />Username: 
			<input id="us" type="text" name="username" />
			<br />Password:
			<input id="ps" type="password" name="password" /> <br />
			<input id="add_button" type="submit" value="Add User">
		</form>
		
		
	<%Class.forName("com.mysql.jdbc.Driver"); %>
	<%Connection connect = DriverManager.getConnection("jdbc:mysql://localhost/bizdata", "sql_admin", "sqlp@ss123"); %>
	<%Statement st = connect.createStatement(); %>
	<%ResultSet result = st.executeQuery("SELECT * FROM users"); %>
	
	<label>Users:</label>
	<%while (result.next()){%>
	<br/>
	<label><%= result.getString("name")%></label>
	<%} %>


</body>
</html>